CREATE TABLE [dbo].[Product]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_PRODUCT_CODE] DEFAULT (''),
[PRODUCT_MAJOR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_PRODUCT_MAJOR] DEFAULT (''),
[PRODUCT_MINOR] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_PRODUCT_MINOR] DEFAULT (''),
[PROD_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_PROD_TYPE] DEFAULT (''),
[CATEGORY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_CATEGORY] DEFAULT (''),
[TITLE_KEY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_TITLE_KEY] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_TITLE] DEFAULT (''),
[DESCRIPTION] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_DESCRIPTION] DEFAULT (''),
[STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_STATUS] DEFAULT (''),
[NOTE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GROUP_1] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_GROUP_1] DEFAULT (''),
[GROUP_2] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_GROUP_2] DEFAULT (''),
[GROUP_3] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_GROUP_3] DEFAULT (''),
[PRICE_RULES_EXIST] [bit] NOT NULL CONSTRAINT [DF_Product_PRICE_RULES_EXIST] DEFAULT ((0)),
[LOT_SERIAL_EXIST] [bit] NOT NULL CONSTRAINT [DF_Product_LOT_SERIAL_EXIST] DEFAULT ((0)),
[PAYMENT_PRIORITY] [int] NOT NULL CONSTRAINT [DF_Product_PAYMENT_PRIORITY] DEFAULT ((0)),
[RENEW_MONTHS] [int] NOT NULL CONSTRAINT [DF_Product_RENEW_MONTHS] DEFAULT ((0)),
[PRORATE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_PRORATE] DEFAULT (''),
[STOCK_ITEM] [bit] NOT NULL CONSTRAINT [DF_Product_STOCK_ITEM] DEFAULT ((0)),
[UNIT_OF_MEASURE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_UNIT_OF_MEASURE] DEFAULT (''),
[WEIGHT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_WEIGHT] DEFAULT ((0)),
[TAXABLE] [bit] NOT NULL CONSTRAINT [DF_Product_TAXABLE] DEFAULT ((0)),
[COMMISIONABLE] [bit] NOT NULL CONSTRAINT [DF_Product_COMMISIONABLE] DEFAULT ((0)),
[COMMISION_PERCENT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_COMMISION_PERCENT] DEFAULT ((0)),
[DECIMAL_POINTS] [int] NOT NULL CONSTRAINT [DF_Product_DECIMAL_POINTS] DEFAULT ((0)),
[INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_INCOME_ACCOUNT] DEFAULT (''),
[DEFERRED_INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_DEFERRED_INCOME_ACCOUNT] DEFAULT (''),
[INVENTORY_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_INVENTORY_ACCOUNT] DEFAULT (''),
[ADJUSTMENT_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_ADJUSTMENT_ACCOUNT] DEFAULT (''),
[COG_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_COG_ACCOUNT] DEFAULT (''),
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_INTENT_TO_EDIT] DEFAULT (''),
[PRICE_1] [money] NOT NULL CONSTRAINT [DF_Product_PRICE_1] DEFAULT ((0)),
[PRICE_2] [money] NOT NULL CONSTRAINT [DF_Product_PRICE_2] DEFAULT ((0)),
[PRICE_3] [money] NOT NULL CONSTRAINT [DF_Product_PRICE_3] DEFAULT ((0)),
[COMPLIMENTARY] [bit] NOT NULL CONSTRAINT [DF_Product_COMPLIMENTARY] DEFAULT ((0)),
[ATTRIBUTES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_ATTRIBUTES] DEFAULT (''),
[PST_TAXABLE] [bit] NOT NULL CONSTRAINT [DF_Product_PST_TAXABLE] DEFAULT ((0)),
[TAXABLE_VALUE] [money] NOT NULL CONSTRAINT [DF_Product_TAXABLE_VALUE] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_ORG_CODE] DEFAULT (''),
[TAX_AUTHORITY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_TAX_AUTHORITY] DEFAULT (''),
[WEB_OPTION] [tinyint] NOT NULL CONSTRAINT [DF_Product_WEB_OPTION] DEFAULT ((0)),
[IMAGE_URL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_IMAGE_URL] DEFAULT (''),
[APPLY_IMAGE] [bit] NOT NULL CONSTRAINT [DF_Product_APPLY_IMAGE] DEFAULT ((0)),
[IS_KIT] [bit] NOT NULL CONSTRAINT [DF_Product_IS_KIT] DEFAULT ((0)),
[INFO_URL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_INFO_URL] DEFAULT (''),
[APPLY_INFO] [bit] NOT NULL CONSTRAINT [DF_Product_APPLY_INFO] DEFAULT ((0)),
[PLP_CODE] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_PLP_CODE] DEFAULT (''),
[PROMOTE] [bit] NOT NULL CONSTRAINT [DF_Product_PROMOTE] DEFAULT ((0)),
[THUMBNAIL_URL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_THUMBNAIL_URL] DEFAULT (''),
[APPLY_THUMBNAIL] [bit] NOT NULL CONSTRAINT [DF_Product_APPLY_THUMBNAIL] DEFAULT ((0)),
[CATALOG_DESC] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WEB_DESC] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OTHER_DESC] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOCATION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_LOCATION] DEFAULT (''),
[PREMIUM] [bit] NOT NULL CONSTRAINT [DF_Product_PREMIUM] DEFAULT ((0)),
[FAIR_MARKET_VALUE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_FAIR_MARKET_VALUE] DEFAULT ((0)),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Product_IS_FR_ITEM] DEFAULT ((0)),
[APPEAL_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_APPEAL_CODE] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_CAMPAIGN_CODE] DEFAULT (''),
[PRICE_FROM_COMPONENTS] [bit] NOT NULL CONSTRAINT [DF_Product_PRICE_FROM_COMPONENTS] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL,
[ProductKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Product_ProductKey] DEFAULT (newid())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product] ADD CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED ([PRODUCT_CODE]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Product] ADD CONSTRAINT [AK_Product_ProductKey] UNIQUE NONCLUSTERED ([ProductKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProductCATEGORY] ON [dbo].[Product] ([CATEGORY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProductPROD_TYPE] ON [dbo].[Product] ([PROD_TYPE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProductPRODUCT_MAJOR] ON [dbo].[Product] ([PRODUCT_MAJOR]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProductTITLE_KEY] ON [dbo].[Product] ([TITLE_KEY]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product] TO [IMIS]
GRANT SELECT ON  [dbo].[Product] TO [IMIS]
GRANT INSERT ON  [dbo].[Product] TO [IMIS]
GRANT DELETE ON  [dbo].[Product] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product] TO [IMIS]
GO